THIRD SEMESTERcoretheorySem 3
DATABASE MANAGEMENT SYSTEM
CSS 2107
Syllabus
- 01Database-System Applications
- 02Database Languages
- 03Relational Databases
- 04Database Design
- 05Data Storage and Querying
- 06Database Architecture
- 07Database Schemas
- 08Keys
- 09Relational Query Languages
- 10Relational Operations
- 11Overview of the Design Process
- 12The Entity-Relationship Model
- 13Extended E-R Features
- 14Reduction to Relational Schemas
- 15Features of Good Relational Design
- 16Atomic Domains and Normalization
- 17File concepts
- 18Indices Concept
- 19Static Hashing
- 20Dynamic Hashing
- 21Comparison of Ordered Indexing and Hashing
- 22Bitmap Indices
- 23Transaction Concept
- 24Failure Classification
- 25Storage
- 26Recovery and Atomicity
- 27Recovery algorithm
- 28Overview
- 29Measuring of Query Cost
- 30Selection Operation
- 31Sorting
- 32Join Operation
- 33Evaluation of Expressions
References
- Ramez Elmasri and Shamkant Navathe, Durvasula V L N Somayajulu, Shyam K Gupta, Fundamentals of Database Systems, (6e), Pearson Education, United States of America, 2011
- Thomas Connolly, Carolyn Begg, Database Systems - A Practical Approach to Design, Implementation and Management, (4e), Pearson Education, England, 2005
- Peter Rob, Carlos Corone l, Database Systems-Design, Implementation and Management, (10e), Course Technology, Boston, 2013
Credits Structure
3Lecture
0Tutorial
0Practical
3Total